SELECT /*+ result_cache */
       count(*),   
       round(avg(quantity_on_hand)) AVG_AMT, 
       product_id, product_name 
FROM inventories natural join product_information
GROUP BY product_id, product_name;
